Tabellen anzeigen

sqlite3 database.sqlite .tables

Abfrage

sqlite3 database.sqlite "select id from notes where id = 'fce29b31438146d0bde9667fdbba5cca'"

Bsp.:

Schau in die Baloo-Datenbank (falls aktiviert):

sqlite3 ~/.local/share/baloo/index/index.db "SELECT * FROM FileContent LIMIT 5;"

sqlite3 ~/.local/share/baloo/index/index.db "SELECT * FROM FileContent LIMIT 5;"